CREATE TABLE [dbo].[FS_Admin]
(
[fdAdmiLoginID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdAdmiPwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdAdmiName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdAdmiLoginIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdAdmiLoginAt] [datetime] NULL,
[fdAdmiPhone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Admin_fdAdmiPhone] DEFAULT (''),
[fdAdmiStatus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Admin_fdAdmiStatus] DEFAULT ((1)),
[fdAdmiAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Admin_fdAdmiAddress] DEFAULT (''),
[fdAdmimobile] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Admin_fdAdmimobile] DEFAULT (''),
[fdAdmiNote] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Admin_fdAdmiNote] DEFAULT (''),
[fdAdmiQuestion] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Admin_fdAdmiQuestion] DEFAULT (''),
[fdAdmiAnswer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Admin_fdAdmiAnswer] DEFAULT (''),
[fdAdmiLevel] [int] NOT NULL CONSTRAINT [DF_FS_Admin_fdAdmiLevel] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FS_Admin] ADD CONSTRAINT [PK_FS_Admin] PRIMARY KEY CLUSTERED  ([fdAdmiLoginID]) ON [PRIMARY]
GO
